<!DOCTYPE html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <title>Code Coverage for C:\www\html\feedback\app\Services/Feedback.php</title>
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <link href="css/bootstrap.min.css" rel="stylesheet">
  <link href="css/bootstrap-responsive.min.css" rel="stylesheet">
  <link href="css/style.css" rel="stylesheet">
  <!--[if lt IE 9]>
  <script src="js/html5shiv.js"></script>
  <![endif]-->
 </head>
 <body>
  <header>
   <div class="container">
    <div class="row">
     <div class="span12">
      <ul class="breadcrumb">
        <li><a href="index.html">C:\www\html\feedback\app\Services</a> <span class="divider">/</span></li>
        <li class="active">Feedback.php</li>

      </ul>
     </div>
    </div>
   </div>
  </header>
  <div class="container">
   <table class="table table-bordered">
    <thead>
     <tr>
      <td>&nbsp;</td>
      <td colspan="10"><div align="center"><strong>Code Coverage</strong></div></td>
     </tr>
     <tr>
      <td>&nbsp;</td>
      <td colspan="3"><div align="center"><strong>Classes and Traits</strong></div></td>
      <td colspan="4"><div align="center"><strong>Functions and Methods</strong></div></td>
      <td colspan="3"><div align="center"><strong>Lines</strong></div></td>
     </tr>
    </thead>
    <tbody>
     <tr>
      <td class="success">Total</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">1&nbsp;/&nbsp;1</div></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">3&nbsp;/&nbsp;3</div></td>
      <td class="success small"><acronym title="Change Risk Anti-Patterns (CRAP) Index">CRAP</acronym></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">59&nbsp;/&nbsp;59</div></td>
     </tr>

     <tr>
      <td class="success">Feedback</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">1&nbsp;/&nbsp;1</div></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">3&nbsp;/&nbsp;3</div></td>
      <td class="success small">13</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">59&nbsp;/&nbsp;59</div></td>
     </tr>

     <tr>
      <td class="success" colspan="4">&nbsp;<a href="#22">prepareInsert($post)</a></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">1&nbsp;/&nbsp;1</div></td>
      <td class="success small">5</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">24&nbsp;/&nbsp;24</div></td>
     </tr>

     <tr>
      <td class="success" colspan="4">&nbsp;<a href="#64">commentSearch($detractors, $passives, $promoters, $from, $to, $business)</a></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">1&nbsp;/&nbsp;1</div></td>
      <td class="success small">7</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">28&nbsp;/&nbsp;28</div></td>
     </tr>

     <tr>
      <td class="success" colspan="4">&nbsp;<a href="#105">markInappropriate($id)</a></td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">1&nbsp;/&nbsp;1</div></td>
      <td class="success small">1</td>
      <td class="success big">       <div class="progress progress-success" style="width: 100px;">
        <div class="bar" style="width: 100.00%;"></div>
       </div>
</td>
      <td class="success small"><div align="right">100.00%</div></td>
      <td class="success small"><div align="right">7&nbsp;/&nbsp;7</div></td>
     </tr>


    </tbody>
   </table>
   <table class="table table-borderless table-condensed">
    <tbody>
     <tr><td><div align="right"><a name="1"></a><a href="#1">1</a></div></td><td class="codeLine">&lt;?php</td></tr>
     <tr><td><div align="right"><a name="2"></a><a href="#2">2</a></div></td><td class="codeLine">namespace Services;</td></tr>
     <tr><td><div align="right"><a name="3"></a><a href="#3">3</a></div></td><td class="codeLine">/**</td></tr>
     <tr><td><div align="right"><a name="4"></a><a href="#4">4</a></div></td><td class="codeLine"> * File holds class for feedback data manipulation</td></tr>
     <tr><td><div align="right"><a name="5"></a><a href="#5">5</a></div></td><td class="codeLine"> *</td></tr>
     <tr><td><div align="right"><a name="6"></a><a href="#6">6</a></div></td><td class="codeLine"> * PHP version 5.3.5</td></tr>
     <tr><td><div align="right"><a name="7"></a><a href="#7">7</a></div></td><td class="codeLine"> *</td></tr>
     <tr><td><div align="right"><a name="8"></a><a href="#8">8</a></div></td><td class="codeLine"> * @category   CM</td></tr>
     <tr><td><div align="right"><a name="9"></a><a href="#9">9</a></div></td><td class="codeLine"> * @package    Services</td></tr>
     <tr><td><div align="right"><a name="10"></a><a href="#10">10</a></div></td><td class="codeLine"> * @subpackage -</td></tr>
     <tr><td><div align="right"><a name="11"></a><a href="#11">11</a></div></td><td class="codeLine"> * @author     markus karileet &lt;markuskarileet@hotmail.com&gt;</td></tr>
     <tr><td><div align="right"><a name="12"></a><a href="#12">12</a></div></td><td class="codeLine"> * @license    http://www.gnu.org/copyleft/gpl.html GNU GPL</td></tr>
     <tr><td><div align="right"><a name="13"></a><a href="#13">13</a></div></td><td class="codeLine"> * @link       -</td></tr>
     <tr><td><div align="right"><a name="14"></a><a href="#14">14</a></div></td><td class="codeLine"> */</td></tr>
     <tr><td><div align="right"><a name="15"></a><a href="#15">15</a></div></td><td class="codeLine">class Feedback extends ORM {</td></tr>
     <tr><td><div align="right"><a name="16"></a><a href="#16">16</a></div></td><td class="codeLine">    /**</td></tr>
     <tr><td><div align="right"><a name="17"></a><a href="#17">17</a></div></td><td class="codeLine">     * Method parses input and then stores to database.</td></tr>
     <tr><td><div align="right"><a name="18"></a><a href="#18">18</a></div></td><td class="codeLine">     * @param array $post HTML POST array</td></tr>
     <tr><td><div align="right"><a name="19"></a><a href="#19">19</a></div></td><td class="codeLine">     * @return \Entities\Feedback Feedback object on success, false on error</td></tr>
     <tr><td><div align="right"><a name="20"></a><a href="#20">20</a></div></td><td class="codeLine">     * @throws \Exception</td></tr>
     <tr><td><div align="right"><a name="21"></a><a href="#21">21</a></div></td><td class="codeLine">     */</td></tr>
     <tr><td><div align="right"><a name="22"></a><a href="#22">22</a></div></td><td class="codeLine">    public function prepareInsert($post) {</td></tr>
     <tr class="success popin" data-title="3 tests cover line 23" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="23"></a><a href="#23">23</a></div></td><td class="codeLine">        $feedback = false;</td></tr>
     <tr class="success popin" data-title="3 tests cover line 24" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="24"></a><a href="#24">24</a></div></td><td class="codeLine">        if(isset($post) &amp;&amp; count($post) &gt; 0) {</td></tr>
     <tr class="success popin" data-title="3 tests cover line 25" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="25"></a><a href="#25">25</a></div></td><td class="codeLine">            $business = new \Entities\Business();</td></tr>
     <tr class="success popin" data-title="3 tests cover line 26" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="26"></a><a href="#26">26</a></div></td><td class="codeLine">            $business-&gt;setCode(\Misc\Tools::cleanInput($post['code']));</td></tr>
     <tr class="success popin" data-title="3 tests cover line 27" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="27"></a><a href="#27">27</a></div></td><td class="codeLine">            $business = $this-&gt;select($business);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 28" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="28"></a><a href="#28">28</a></div></td><td class="codeLine">            $feedback = new \Entities\Feedback();</td></tr>
     <tr class="success popin" data-title="3 tests cover line 29" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="29"></a><a href="#29">29</a></div></td><td class="codeLine">            $feedback-&gt;setBusiness($business-&gt;getId());</td></tr>
     <tr class="success popin" data-title="3 tests cover line 30" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="30"></a><a href="#30">30</a></div></td><td class="codeLine">            $feedback-&gt;setComment(\Misc\Tools::cleanInput($post['comment']));</td></tr>
     <tr class="success popin" data-title="3 tests cover line 31" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="31"></a><a href="#31">31</a></div></td><td class="codeLine">            if (@$post['score'] == '-1') {</td></tr>
     <tr class="success popin" data-title="1 test covers line 32" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="32"></a><a href="#32">32</a></div></td><td class="codeLine">                $score = null;</td></tr>
     <tr class="success popin" data-title="1 test covers line 33" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="33"></a><a href="#33">33</a></div></td><td class="codeLine">            } else {</td></tr>
     <tr class="success popin" data-title="2 tests cover line 34" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="34"></a><a href="#34">34</a></div></td><td class="codeLine">                $score = (int)$post['score'];</td></tr>
     <tr><td><div align="right"><a name="35"></a><a href="#35">35</a></div></td><td class="codeLine">            }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 36" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="36"></a><a href="#36">36</a></div></td><td class="codeLine">            $feedback-&gt;setRating($score);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 37" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="37"></a><a href="#37">37</a></div></td><td class="codeLine">            $feedback-&gt;setInappropriate(\Enum\Feedback::Appropriate);</td></tr>
     <tr><td><div align="right"><a name="38"></a><a href="#38">38</a></div></td><td class="codeLine">            //allow time override when input is from integration!</td></tr>
     <tr class="success popin" data-title="3 tests cover line 39" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="39"></a><a href="#39">39</a></div></td><td class="codeLine">            if (isset($post['time'])) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 40" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="40"></a><a href="#40">40</a></div></td><td class="codeLine">                $time = strtotime($post['time']);</td></tr>
     <tr class="success popin" data-title="1 test covers line 41" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="41"></a><a href="#41">41</a></div></td><td class="codeLine">            } else {</td></tr>
     <tr class="success popin" data-title="2 tests cover line 42" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="42"></a><a href="#42">42</a></div></td><td class="codeLine">                $time = time();</td></tr>
     <tr><td><div align="right"><a name="43"></a><a href="#43">43</a></div></td><td class="codeLine">            }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 44" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="44"></a><a href="#44">44</a></div></td><td class="codeLine">            $feedback-&gt;setTime($time);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 45" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="45"></a><a href="#45">45</a></div></td><td class="codeLine">            $feedback-&gt;setUser($post['uid']);</td></tr>
     <tr><td><div align="right"><a name="46"></a><a href="#46">46</a></div></td><td class="codeLine"></td></tr>
     <tr class="success popin" data-title="3 tests cover line 47" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="47"></a><a href="#47">47</a></div></td><td class="codeLine">            $id = $this-&gt;insert($feedback);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 48" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="48"></a><a href="#48">48</a></div></td><td class="codeLine">            $feedback-&gt;setId($id);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 49" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="49"></a><a href="#49">49</a></div></td><td class="codeLine">        }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 50" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testInsertWithoutScore&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="50"></a><a href="#50">50</a></div></td><td class="codeLine">        return $feedback;</td></tr>
     <tr><td><div align="right"><a name="51"></a><a href="#51">51</a></div></td><td class="codeLine">    }</td></tr>
     <tr><td><div align="right"><a name="52"></a><a href="#52">52</a></div></td><td class="codeLine"></td></tr>
     <tr><td><div align="right"><a name="53"></a><a href="#53">53</a></div></td><td class="codeLine">    /**</td></tr>
     <tr><td><div align="right"><a name="54"></a><a href="#54">54</a></div></td><td class="codeLine">     * Method searches for comments by rater type and time</td></tr>
     <tr><td><div align="right"><a name="55"></a><a href="#55">55</a></div></td><td class="codeLine">     * @param int $detractors Flag whether to show detractors</td></tr>
     <tr><td><div align="right"><a name="56"></a><a href="#56">56</a></div></td><td class="codeLine">     * @param int $passives Flag whether to show passives</td></tr>
     <tr><td><div align="right"><a name="57"></a><a href="#57">57</a></div></td><td class="codeLine">     * @param int $promoters Flag whether to show promoters</td></tr>
     <tr><td><div align="right"><a name="58"></a><a href="#58">58</a></div></td><td class="codeLine">     * @param var $from Date from</td></tr>
     <tr><td><div align="right"><a name="59"></a><a href="#59">59</a></div></td><td class="codeLine">     * @param var $to Date to</td></tr>
     <tr><td><div align="right"><a name="60"></a><a href="#60">60</a></div></td><td class="codeLine">     * @param int $business Company ID</td></tr>
     <tr><td><div align="right"><a name="61"></a><a href="#61">61</a></div></td><td class="codeLine">     * @return array Array of feedbacks when found. False otherwise</td></tr>
     <tr><td><div align="right"><a name="62"></a><a href="#62">62</a></div></td><td class="codeLine">     * @throws \Exception</td></tr>
     <tr><td><div align="right"><a name="63"></a><a href="#63">63</a></div></td><td class="codeLine">     */</td></tr>
     <tr><td><div align="right"><a name="64"></a><a href="#64">64</a></div></td><td class="codeLine">    public function commentSearch($detractors, $passives, $promoters, $from, $to, $business) {</td></tr>
     <tr class="success popin" data-title="3 tests cover line 65" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="65"></a><a href="#65">65</a></div></td><td class="codeLine">        $out = false;</td></tr>
     <tr class="success popin" data-title="3 tests cover line 66" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="66"></a><a href="#66">66</a></div></td><td class="codeLine">        $raters = array();</td></tr>
     <tr class="success popin" data-title="3 tests cover line 67" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="67"></a><a href="#67">67</a></div></td><td class="codeLine">        if ($detractors &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 68" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="68"></a><a href="#68">68</a></div></td><td class="codeLine">            $raters[] = ' `rating` BETWEEN ' . \Enum\NPS::Detractors . ' AND ' . (\Enum\NPS::Passive - 1);</td></tr>
     <tr class="success popin" data-title="1 test covers line 69" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="69"></a><a href="#69">69</a></div></td><td class="codeLine">        }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 70" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="70"></a><a href="#70">70</a></div></td><td class="codeLine">        if ($passives &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 71" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="71"></a><a href="#71">71</a></div></td><td class="codeLine">            $raters[] = ' `rating` BETWEEN ' . \Enum\NPS::Passive . ' AND ' . (\Enum\NPS::Promoters - 1);</td></tr>
     <tr class="success popin" data-title="1 test covers line 72" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="72"></a><a href="#72">72</a></div></td><td class="codeLine">        }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 73" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="73"></a><a href="#73">73</a></div></td><td class="codeLine">        if ($promoters &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 74" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="74"></a><a href="#74">74</a></div></td><td class="codeLine">            $raters[] = ' `rating` BETWEEN ' . \Enum\NPS::Promoters . ' AND 10';</td></tr>
     <tr class="success popin" data-title="1 test covers line 75" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="75"></a><a href="#75">75</a></div></td><td class="codeLine">        }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 76" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="76"></a><a href="#76">76</a></div></td><td class="codeLine">        $sql = 'SELECT * FROM `feedback` where `business` = %d %s';</td></tr>
     <tr class="success popin" data-title="3 tests cover line 77" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="77"></a><a href="#77">77</a></div></td><td class="codeLine">        $appendix = '';</td></tr>
     <tr class="success popin" data-title="3 tests cover line 78" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="78"></a><a href="#78">78</a></div></td><td class="codeLine">        if (count($raters) &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 79" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="79"></a><a href="#79">79</a></div></td><td class="codeLine">            $appendix = ' AND (' . implode(' OR ', $raters) . ')';</td></tr>
     <tr class="success popin" data-title="1 test covers line 80" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="80"></a><a href="#80">80</a></div></td><td class="codeLine">        }</td></tr>
     <tr class="success popin" data-title="3 tests cover line 81" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="81"></a><a href="#81">81</a></div></td><td class="codeLine">        $dates = '';</td></tr>
     <tr class="success popin" data-title="3 tests cover line 82" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="82"></a><a href="#82">82</a></div></td><td class="codeLine">        if (strlen($from) &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 83" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="83"></a><a href="#83">83</a></div></td><td class="codeLine">            $dates = sprintf(&quot; AND `time` &gt;= '%s' &quot;, strtotime($from));</td></tr>
     <tr class="success popin" data-title="1 test covers line 84" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="84"></a><a href="#84">84</a></div></td><td class="codeLine">        }</td></tr>
     <tr><td><div align="right"><a name="85"></a><a href="#85">85</a></div></td><td class="codeLine">        //add 1 day to 'to' date, so that user can search comments for 1 day only:</td></tr>
     <tr><td><div align="right"><a name="86"></a><a href="#86">86</a></div></td><td class="codeLine">        //etc: from 16.01.2012 to 16.01.2012 will show comments for that day</td></tr>
     <tr class="success popin" data-title="3 tests cover line 87" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="87"></a><a href="#87">87</a></div></td><td class="codeLine">        if (strlen($to) &gt; 0) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 88" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="88"></a><a href="#88">88</a></div></td><td class="codeLine">            $dates .= sprintf(&quot; AND `time` &lt;= '%s' &quot;, strtotime('+1 day', strtotime($to)));</td></tr>
     <tr class="success popin" data-title="1 test covers line 89" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="89"></a><a href="#89">89</a></div></td><td class="codeLine">        }</td></tr>
     <tr><td><div align="right"><a name="90"></a><a href="#90">90</a></div></td><td class="codeLine"></td></tr>
     <tr class="success popin" data-title="3 tests cover line 91" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="91"></a><a href="#91">91</a></div></td><td class="codeLine">        $preparedSql = sprintf($sql, $business, $dates);</td></tr>
     <tr class="success popin" data-title="3 tests cover line 92" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="92"></a><a href="#92">92</a></div></td><td class="codeLine">        $preparedSql .= $appendix;</td></tr>
     <tr class="success popin" data-title="3 tests cover line 93" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="93"></a><a href="#93">93</a></div></td><td class="codeLine">        $preparedSql .= ' ORDER BY `time` ASC';</td></tr>
     <tr class="success popin" data-title="3 tests cover line 94" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="94"></a><a href="#94">94</a></div></td><td class="codeLine">        $out = $this-&gt;rawQuery($preparedSql, new \Entities\Feedback());</td></tr>
     <tr><td><div align="right"><a name="95"></a><a href="#95">95</a></div></td><td class="codeLine"></td></tr>
     <tr class="success popin" data-title="3 tests cover line 96" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithoutAnything&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithTime&lt;/li&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testCommentSearchWithRaters&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="96"></a><a href="#96">96</a></div></td><td class="codeLine">        return $out;</td></tr>
     <tr><td><div align="right"><a name="97"></a><a href="#97">97</a></div></td><td class="codeLine">    }</td></tr>
     <tr><td><div align="right"><a name="98"></a><a href="#98">98</a></div></td><td class="codeLine"></td></tr>
     <tr><td><div align="right"><a name="99"></a><a href="#99">99</a></div></td><td class="codeLine">    /**</td></tr>
     <tr><td><div align="right"><a name="100"></a><a href="#100">100</a></div></td><td class="codeLine">     * Method marks comment as inappropriate and updates DB</td></tr>
     <tr><td><div align="right"><a name="101"></a><a href="#101">101</a></div></td><td class="codeLine">     * @param int $id Feedback ID</td></tr>
     <tr><td><div align="right"><a name="102"></a><a href="#102">102</a></div></td><td class="codeLine">     * @return \Entities\Feedback inappropriate feedback object</td></tr>
     <tr><td><div align="right"><a name="103"></a><a href="#103">103</a></div></td><td class="codeLine">     * @throws \Exception when database transactions fail</td></tr>
     <tr><td><div align="right"><a name="104"></a><a href="#104">104</a></div></td><td class="codeLine">     */</td></tr>
     <tr><td><div align="right"><a name="105"></a><a href="#105">105</a></div></td><td class="codeLine">    public function markInappropriate($id) {</td></tr>
     <tr class="success popin" data-title="1 test covers line 106" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="106"></a><a href="#106">106</a></div></td><td class="codeLine">        $this-&gt;_logger-&gt;debug(sprintf('Marking comment %d as inappropriate!', $id));</td></tr>
     <tr><td><div align="right"><a name="107"></a><a href="#107">107</a></div></td><td class="codeLine">        //Update feedback object</td></tr>
     <tr class="success popin" data-title="1 test covers line 108" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="108"></a><a href="#108">108</a></div></td><td class="codeLine">        $comTmpl = new \Entities\Feedback();</td></tr>
     <tr class="success popin" data-title="1 test covers line 109" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="109"></a><a href="#109">109</a></div></td><td class="codeLine">        $comTmpl-&gt;setId($id);</td></tr>
     <tr class="success popin" data-title="1 test covers line 110" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="110"></a><a href="#110">110</a></div></td><td class="codeLine">        $com = $this-&gt;select($comTmpl);</td></tr>
     <tr class="success popin" data-title="1 test covers line 111" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="111"></a><a href="#111">111</a></div></td><td class="codeLine">        $com-&gt;setInappropriate(\Enum\Feedback::Inappropriate);</td></tr>
     <tr class="success popin" data-title="1 test covers line 112" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="112"></a><a href="#112">112</a></div></td><td class="codeLine">        $this-&gt;update($com);</td></tr>
     <tr><td><div align="right"><a name="113"></a><a href="#113">113</a></div></td><td class="codeLine"></td></tr>
     <tr class="success popin" data-title="1 test covers line 114" data-content="&lt;ul&gt;&lt;li class=&quot;success&quot;&gt;FeedbackTest::testMarkInappropriate&lt;/li&gt;&lt;/ul&gt;" data-placement="bottom" data-html="true"><td><div align="right"><a name="114"></a><a href="#114">114</a></div></td><td class="codeLine">        return $com;</td></tr>
     <tr><td><div align="right"><a name="115"></a><a href="#115">115</a></div></td><td class="codeLine">    }</td></tr>

    </tbody>
   </table>
   <footer>
    <h4>Legend</h4>
    <p>
     <span class="success"><strong>Executed</strong></span>
     <span class="danger"><strong>Not Executed</strong></span>
     <span class="warning"><strong>Dead Code</strong></span>
    </p>
    <p>
     <small>Generated by <a href="http://github.com/sebastianbergmann/php-code-coverage" target="_top">PHP_CodeCoverage 1.2.12</a> using <a href="http://www.php.net/" target="_top">PHP 5.3.10</a> and <a href="http://phpunit.de/">PHPUnit 3.7.24</a> at Thu Sep 12 10:14:44 EEST 2013.</small>
    </p>
   </footer>
  </div>
  <script src="js/jquery.min.js" type="text/javascript"></script>
  <script src="js/bootstrap.min.js" type="text/javascript"></script>
  <script type="text/javascript">$('.popin').popover({trigger: 'hover'});</script>
 </body>
</html>
